package org.cwnuit.train.service;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import org.apache.log4j.Logger;
import org.cwnuit.train.dao.NoticesDAO;
import org.cwnuit.train.domain.Notices;
import org.cwnuit.train.domain.Trains;
import org.cwnuit.train.domain.Users;
import org.cwnuit.train.utils.ConnDB;
import org.cwnuit.train.utils.EntityUtil;
import org.cwnuit.train.utils.PageModel;

@SuppressWarnings("all")
public class NoticesService {

	private NoticesDAO noticesDAO = new NoticesDAO();
	
	public PageModel findByPage(int offset, int pagesize, String SQL) {
		return noticesDAO.findByPage(offset, pagesize, SQL);
	}
	
	public boolean addNotice(String SQL) {
		return noticesDAO.addNotice(SQL);
	}

	public boolean updateNotice(String SQL) {
		return noticesDAO.updateNotice(SQL);
	}

	public boolean deleteNotice(String SQL) {
		return noticesDAO.deleteNotice(SQL);
	}

	public Notices findNotice(String SQL) {
		return noticesDAO.findNotice(SQL);
	}
	
}
